Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_APPLY_SPILL_TXN

`DBA_APPLY_SPILL_TXN` displays information about the transactions spilled from memory to hard disk by all of the Streams apply processes in the database.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`APPLY_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the apply that spilled one or more transactions
`XIDUSN` | `NUMBER` | `NOT NULL` | Transaction ID undo segment number
`XIDSLT` | `NUMBER` | `NOT NULL` | Transaction ID slot number
`XIDSQN` | `NUMBER` | `NOT NULL` | Transaction ID sequence number
`FIRST_SCN` | `NUMBER` | `NOT NULL` | SCN of first message in this transaction
`MESSAGE_COUNT` | `NUMBER` |  | Number of messages spilled for this transaction
`FIRST_MESSAGE_CREATE_TIME` | `DATE` |  | Source creation time of the first message in this transaction
`SPILL_CREATION_TIME` | `DATE` |  | Time first message was spilled